Dynamic place holders give users the ability to configure slicer-driven dynamic text within Present and Publish. The text will change dynamically according to the slicer selection.
Configure a Dynamic Place Holder
To configure a dynamic place holder:
- Add a textbox to the slide and enter the required text.
- With the textbox selected, go to the text ribbon, open the Dynamic Text drop-down list and select Place Holder (purple highlight below).
- Use the Interaction Manager to configure the data interaction(s) between the slicer(s) and the text.
- You can also write a PQL expression to drive the place holder.
When the presentation is launched in runtime, the dynamic placeholders will change dynamically according to the slicer selections.
Interaction Manager
From the Interaction Manager, manage interactions and slicers for content items that are on the currently selected slide. You can add, remove, and edit interactions, add and delete slicers, and view slicer settings.
Open the Interaction Manager to define interactions between the placeholders (purple highlight below) and the slicers (yellow highlight below). Each place holder can have a single interaction with one slicer.
Example: Add Dynamic Place Holders
STEP 1
Add a textbox to the canvas, and write your text in it.
STEP 2
Add a dynamic place holder to the parts of the text that should be dynamic.
In this example, the dynamic text will explain the sales in dollars according to the product category, country, and promotion specified in the slicers.
STEP 3
Add the required slicers to the canvas either from the content tree, or by accessing the New Slicer wizard from the Home ribbon.
STEP 4
Open the Interaction Manager to add interactions from the slicer(s) to the dynamic place holder(s).
STEP 5
Add interactions between the slicers and the other visuals if required, and add any other dynamic text that's required.
STEP 6
Preview the presentation to test the dynamic text.
Configure Dynamic Place Holder Expressions
Use the Dynamic Place Holder Editor to write PQL expressions to drive the place holder.
To open the Dynamic Place Holder editor, simply click on the placeholder in its textbox; the editor will open along the bottom of the interface. By default, the existing formula will be:
value()
To add a PQL function from the library to the script editor, simply double click on it. You will then need to inject values into the function.
PQL Functions
The Pyramid Query Language or PQL (pronounced 'Prequel') is a language built into Pyramid's PYRANA engine to allow users to construct queries that can run against the many SQL data stacks that Pyramid can query natively. PQL includes a vast array of operations and functions that allows users to query data and build analytical logic.
The Dynamic Place Holder Editor exposes Dynamic and Common functions. Dynamic functions are a set of specialized method that are designed to act on a given query 's result set. Common functions are a set of methods that are found in most programmatic and mathematical function libraries. These functions are used to perform logic on basic data without concern for data structures, context, or even source.
Example. EndsWith
Here, the place holder will return True is the item selected from the slicer ends in "ries", or False if it doesn't:
Example: Bold
In this example, the place holder text will be bold:
Using the ChatGPT AI-Driven PQL Function
Pyramid's Generative AI integration enables you to use AI to generate scripts and images, dynamic text and infographics, calculations and lists, schedules, colors, and more. This allows you to generate a range of content, including complex code, by simply providing a text prompt.
Use the ChatGPT AI-driven PQL function (from the Common PQL functions) to generate dynamic text. While this function cannot tell you about your data set, it can add additional information and background to your presentation. You can also use your data to drive the results generated by OpenAI's ChatGPT by creating interactions between visualizations and/ or slicers, and the dynamic place holder where the ChatGPT PQL function is injected.
Warning: AI-generated assets are generated from public domain algorithms, which can produce both erroneous and inconsistent/ random results. Use at your own risk.
Example. Using the ChatGPT AI-Driven PQL Function with Place Holders
In this example, an interaction was added from a Country slicer to the dynamic place holder. The place holder is driven by the Chat GPT function. When the presentation is launched in runtime, the place holder returns information about landmarks in the given country.
The Chat GPT expression is configured from the Dynamic Place Holder Editor:
When launched in runtime, the place holder returns information about landmarks in the country selected from the slicer:
